Parameters Provided:
name.synonym = (1R,4S,4aS,5R,6R,7S,8S,8aR)-1,2,3,4,10,10-Hexachloro-1,4,4a,5,6,7,8,8a-octahydro-6,7-epoxy-1,4:5,8-dimethanonaphthalene; (1aalpha,2beta,2aalpha,3beta,6beta,6aalpha,7beta,7aalpha)-3,4,5,6,9,9-hexachloro-1a,2,2a,3,6,6a,7,7a-octahydro-2,7:3,6-dimethanonaphth
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '(1R,4S,4aS,5R,6R,7S,8S,8aR)-1,2,3,4,10,10-Hexachloro-1,4,4a,5,6,7,8,8a-octahydro-6,7-epoxy-1,4:5,8-dimethanonaphthalene; (1aalpha,2beta,2aalpha,3beta,6beta,6aalpha,7beta,7aalpha)-3,4,5,6,9,9-hexachloro-1a,2,2a,3,6,6a,7,7a-octahydro-2,7:3,6-dimethanonaphth' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=%281R%2C4S%2C4aS%2C5R%2C6R%2C7S%2C8S%2C8aR%29-1%2C2%2C3%2C4%2C10%2C10-Hexachloro-1%2C4%2C4a%2C5%2C6%2C7%2C8%2C8a-octahydro-6%2C7-epoxy-1%2C4%3A5%2C8-dimethanonaphthalene%3B+%281aalpha%2C2beta%2C2aalpha%2C3beta%2C6beta%2C6aalpha%2C7beta%2C7aalpha%29-3%2C4%2C5%2C6%2C9%2C9-hexachloro-1a%2C2%2C2a%2C3%2C6%2C6a%2C7%2C7a-octahydro-2%2C7%3A3%2C6-dimethanonaphth&filter.purchasability=all
Embed Link to Results